/*
 * @(#)OptionsListConstant.java
 *
 * Copyright (c) 2003 DCIVision Ltd
 * All rights reserved.
 *
 * This software is the confidential and proprietary information of DCIVision
 * Ltd ("Confidential Information").  You shall not disclose such Confidential
 * Information and shall use it only in accordance with the terms of the license
 * agreement you entered into with DCIVision Ltd.
 */
package com.dcivision.framework;

/**
  OptionsListConstant.java

  This class is to store all option list name constants which used in for HTML
  options tag.

    @author          Rollo Chan
    @company         DCIVision Limited
    @creation date   09/07/2003
    @version         $Revision: 1.21 $
*/

public class OptionsListConstant {

  public static final String REVISION = "$Revision: 1.21 $";

  private OptionsListConstant() {
  }

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, COUNTRY_NAME
   * FROM     SETUP_OPTION_COUNTRY
   * WHERE    RECORD_STATUS = 'A'
   * ORDER BY COUNTRY_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_COUNTRY = "countryList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, SALUTATION_NAME
   * FROM     SETUP_OPTION_SALUTATION
   * WHERE    RECORD_STATUS = 'A'
   * ORDER BY SALUTATION_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_SALUTATION = "salutationList";

  /**
   *  <p>retrieved from:</p>
   *  <pre><code>
   *  SELECT ID, FULL_NAME
   * FROM USER_RECORD
   * WHERE RECORD_STATUS = 'A'
   * ORDER BY FULL_NAME ASC
   *  </code></pre>
   */
  public final static String DBLIST_USER_RECORD = "userRecordList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, GROUP_NAME
   * FROM     USER_GROUP
   * WHERE    RECORD_STATUS = 'A' AND GROUP_TYPE = 'P'
   * ORDER BY GROUP_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_USER_PUBLIC_GROUP = "userPublicGroupList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, GROUP_NAME
   * FROM     USER_GROUP
   * WHERE    RECORD_STATUS = 'A' AND GROUP_TYPE = 'V' AND OWNER_USER_RECORD_ID = {0}
   * ORDER BY GROUP_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_CONTACT_CATEGORY = "contactcategoryList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, GROUP_NAME
   * FROM     USER_GROUP
   * WHERE    RECORD_STATUS = 'A' AND GROUP_TYPE = 'V' AND OWNER_USER_RECORD_ID = {0}
   * ORDER BY GROUP_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_USER_PRIVATE_GROUP = "userPrivateGroupList";
  
  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, ROLE_NAME
   * FROM     USER_ROLE
   * WHERE    RECORD_STATUS = 'A'
   * ORDER BY ROLE_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_USER_ROLE = "userRoleList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, GROUP_NAME
   * FROM     WORKFLOW_GROUP
   * WHERE    RECORD_STATUS = 'A'
   * ORDER BY GROUP_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_WORKFLOW_GROUP = "workflowGroupList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, WORKFLOW_CATEGORY_NAME
   * FROM     SETUP_OPTION_WORKFLOW_CATEGORY
   * WHERE    RECORD_STATUS = 'A'
   * ORDER BY WORKFLOW_CATEGORY_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_WORKFLOW_CATEGORY = "setupOptionWorkflowCategoryList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, NAME
   * FROM     STAFF_HIERARCHY
   * WHERE    RECORD_STATUS = 'A' AND PARENT_ID = {0}
   * ORDER BY NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_STAFF_HIERARCHY = "staffHierarchyList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT     ID, STEP_SEQ + '.' + STEP_NAME AS STEP_DISPLAY_NAME
   * FROM       WORKFLOW_STEP
   * WHERE    RECORD_STATUS = 'A' AND WORKFLOW_RECORD_ID = {0}
   * ORDER BY NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_WORKFLOW_STEP = "workflowStepList";

  /**
   *  <p>retrieved from:</p>
   *  <pre><code>
   *  SELECT ID, USER_DEFINED_TYPE
   * FROM SYS_USER_DEFINED_INDEX
   * WHERE RECORD_STATUS = 'A' AND OBJECT_TYPE ='D'
   * ORDER BY USER_DEFINED_TYPE ASC
   *  </code></pre>
   */
  public final static String DBLIST_DMS_USER_DEFINED_INDEX = "dmsUserDefinedIndexList";
  
  /**
   *  <p>retrieved from:</p>
   *  <pre><code>
   *  SELECT ID, FIELD_NAME
   * FROM SYS_USER_DEFINED_INDEX_DETAIL
   * WHERE RECORD_STATUS = 'A' AND USER_DEFINED_INDEX_ID =?
   * ORDER BY FIELD_NAME ASC
   *  </code></pre>
   */
  public final static String DBLIST_DMS_USER_DEFINED_INDEX_DETAIL = "dmsUserDefinedIndexDetailList";
  
  // ==================== LIST NAME CONSTANT ===============================
  /**
   * <p>List content:</p>
   * <code>
   * LIKE, =, <>, >=, >, <, <=
   * </code>
   */
  public final static String LIST_CRITERIA = "criteriaList";

  /**
   * <p>List content:</p>
   * <code>
   * A (Active), I (Inactive)
   * </code>
   */
  public final static String LIST_STATUS_TYPE = "statusTypeList";

  /**
   * <p>List content:</p>
   * <code>
   * P (Pending), R (Released)
   * </code>
   */
  public final static String LIST_RELEASE_STATUS = "releaseStatusList";

  /**
   * <p>List content:</p>
   * <code>
   * H (High), M (Medium), L (Low)
   * </code>
   */
  public final static String LIST_WORKFLOW_PRIORITY = "workflowPriorityList";

  /**
   * <p>List content:</p>
   * <code>
   * P (Pending), S (Submitted), A (Approved), R (Rejected), G (Completed), N (No Response)
   * </code>
   */
  public final static String LIST_WORKFLOW_PROGRESS_STATUS = "workflowProgressList";

  /**
   * <p>List content:</p>
   * <code>
   * K (Keep Waiting), C (Treat As Completed), S (Stop The Workflow), O (Route To Another Step)
   * </code>
   */
  public final static String LIST_TO_DO_TASK_NO_RESPONSE_ACTION = "toDoTaskNoResponseAction";

  /**
   * <p>List content:</p>
   * <code>
   * K (Keep Waiting), A (Treat As Approved), R (Treat As Rejected), S (Stop The Workflow), O (Route To Another Step)
   * </code>
   */
  public final static String LIST_APPROVAL_TASK_NO_RESPONSE_ACTION = "approvalTaskNoResponseAction";

  /**
   * <p>List content:</p>
   * <code>
   * 1;B (1 Minues), 1;C (1 Hour), etc
   * </code>
   */
  public final static String LIST_REMINDER_AMOUNT = "reminderAmount";


  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   ID, ROOT_NAME
   * FROM     DMS_ROOT
   * WHERE    RECORD_STATUS = 'A' AND (ID = ?)
   * ORDER BY ID ASC
   * </code></pre>
   */
  public final static String DBLIST_ALL_ACCESSABLE_ROOT_LIST = "allAccessableRootList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT ID, FORM_CATEGORY_NAME
   * FROM SETUP_OPTION_FORM_CATEGORY
   * WHERE RECORD_STATUS='A'
   * ORDER BY FORM_CATEGORY_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_FORM_CATEGORY = "formCategoryList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   RELATIONSHIP_CODE, RELATIONSHIP_NAME
   * FROM     SETUP_OPTION_DOC_RELATIONSHIP
   * WHERE    RECORD_STATUS = 'A'  AND STATUS = 'A'
   * ORDER BY DISPLAY_SEQ ASC, RELATIONSHIP_NAME ASC
   * </code></pre>
   */

  public final static String DBLIST_DOCUMENT_RELATIONSHIP = "dmsDocumentRelationshipList";

  /**
   * <p>Retrieved from:</p>
   * <pre><code>
   * SELECT   RELATIONSHIP_CODE, RELATIONSHIP_NAME
   * FROM     SETUP_OPTION_DOC_RELATIONSHIP
   * WHERE    RECORD_STATUS = 'A'  AND STATUS = 'A'
   * AND      RELATIONSHIP_CODE <>"L"
   * ORDER BY DISPLAY_SEQ ASC, RELATIONSHIP_NAME ASC
   * </code></pre>
   */
  public final static String DBLIST_DOCUMENT_NON_SHORTCUT_RELATIONSHIP = "dmsNonShortcutDocumentRelationshipList" ;

  /**
   * <p>retrieved from:</p>
   * <pre><code>
   * SELECT ID, FULL_NAME
   * FROM STAFF_RECORD
   * WHERE RECORD_STATUS = 'A'
   * ORDER BY FULL_NAME ASC
   *  </code></pre>

   */
  public final static String DBLIST_STAFF_RECORD = "staffRecordList";
  
  /**
   <p>retrieved from:</p>
   * <pre><code>
   * SELECT LOC_PATH
   * FROM DMS_LOC_MASTER
   * WHERE RECORD_STATUS = 'A'
   * ORDER BY LOC_PATH ASC
   *  </code></pre>
   */
  public final static String DBLIST_LOC_MASTER ="locMasterList";
  
  /**
  <p>retrieved from:</p>
  * <pre><code>
  * SELECT ID,FIRST_NAME
  * FROM CONTACT_PERSON
  * WHERE RECORD_STATUS = 'A'
  * ORDER BY FIRST_NAME ASC
  *  </code></pre>
  */
 public final static String DBLIST_CONTACT_PERSON ="contactPersonList";
 
 /**
 <p>retrieved from:</p>
 * <pre><code>
 * SELECT ID,CONTACT_LIST_NAME
 * FROM CONTACT_LIST
 * WHERE RECORD_STATUS = 'A'
 * ORDER BY CONTACT_LIST ASC
 *  </code></pre>
 */
 public final static String DBLIST_CONTACT_LIST ="contactList";
 
 /**
 <p>retrieved from:</p>
 * <pre><code>
 * SELECT ID,HOLIDAY_NAME
 * FROM HOLIDAY_RECORD
 * WHERE RECORD_STATUS = 'A'
 * AND REFERENCE_FLAG = '0'
 * ORDER BY CONTACT_LIST ASC
 *  </code></pre>
 */
public final static String DBLIST_HOLIDAY_REFERENCE_LIST ="holidayReferenceList";
 
}